package DBLayer;
import ModelLayer.*;

import java.sql.SQLException;
import java.util.ArrayList;

public interface IFDBProduct {
    // get all Products
    public ArrayList<Product> getAllProducts();
    //get one Product having the productID
    public Product findProduct(int productID) throws SQLException, Exception;
    //find one Product having the clothingID
    public Product searchProduct(int productID) throws SQLException, Exception;
    //find one Product having the product name
    public Product searchProductPname(String pname) throws SQLException, Exception;
    //find products having minStock
    public ArrayList<Product> searchProductMinStock(int minStock);
    //find products having curStock
    public ArrayList<Product> searchProductCurStock(int curStock);
    //insert a new Product
    public void insertProduct(Product product) throws SQLException;
    //update information about a Product
    public void updateProduct(Product product) throws SQLException;
    //rid of product
    public void deleteProduct(int productID) throws SQLException;
}